Databases - MSSQL Server 2008, 2012, 2014, 2016.
Experience of SQL Server Clustering, log-shipping, Mirroring and transactional replication in a high availability 24/7 environment
Microsoft Always on technologies (AOFCI, AOAG).
Installation, configuration and upgrading of Oracle server software and related products.
Establish and maintain sound backup and recovery policies and procedures.
Take care of the Database design and implementation.
Implement and maintain database security (create/maintain users and roles, privileges).
Perform database tuning and performance monitoring
Plan growth and changes (capacity planning).
Work as part of a team and provide 7x24 support when required
Perform general technical trouble shooting and give consultation to development teams.
Thorough knowledge in Windows 2000/2003/2008/2012 networking environment.
Extensive knowledge in Microsoft Windows Platforms (2008, 2012 Exchange Server, Active Directory.
Configuration and Managing of Servers and Workstations.
Extensive knowledge in Computer Hardware.
Tools SQL Developer.
Operating System Linux, Windows 2012, .
MS Word, Excel, PowerPoint, Visio.
Languages - C#, Asp.net, HTML, Visual basics 6.0.
Applications Norton/McAfee Anti-Virus, Norton Internet Security.
Strong knowledge of LAN and WAN.
Shared and Network Printer installation.
Solid knowledge of IT Help Desk system, And remote control.
Administers and maintains the databases.
Installs and upgrades the DBMS as needed. Monitors and optimizes the databases.
Performs backup and recovery of all databases. Manages database users.
Takes appropriate measures to ensure the security of the databases data.
Performs all system maintenance for the databases.
Provides technical assistance to staff using the databases.
Recommends hardware upgrades to the database server as needed. Develops policies to ensure the security and confidentiality of the vendors identifiable data.
Monitors research staffs compliance with confidentiality policies to assure that security standards are met.
Data Processing and Analysis Assures the quality of data feeds and data systems.
Develops standardized programming and data documentation procedures relevant to the vendors data systems.
Assists in the management for the hardware and software as related to the operations of the SQL Server/Oracle DBs, including system development and maintenance, recommends purchase of new hardware and software maintenance of records and reports relating to database operations, data/project archives, and disk maintenance.
• Installs and upgrades the DBMS as needed
• Database development with stored procedures, user defined functions,
• Backup and recovery of all databases
• Manages database users
• Performs all system maintenance for the databases
• Recommends hardware upgrades to the database server as needed
• Work as part of a team and provide 7x24 support when required
• Programming using languages like C# and .net
• Worked with .net platforms like 3.0, 3.5 and 4.0
• Planning, designing and coding for projects
• Communicating with clients and developing necessary code structures for them
• Evaluate issues related to software stated by the clients